UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W9Qg4IA6si4dHxUhHTOGcD7kkT/4T6C62+rjfAD8qWc='
WHERE
key_id = '9d9e5f1213209fd141266268b26f261de2b2f9d604bed34be29defd5328df2d1'
AND (
token = 'W9Qg4IA6si4dHxUhHTOGcD7kkT/4T6C62+rjfAD8qWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)