UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mezvZho5lDnrkcLGcWoqIRrLI0Tj88wjENAsUXB4keA='
WHERE
key_id = 'f2e0238c22ee1ff77da6038a2866dc3e6bb2b715d2c9ebf19b636ad4a39f6814'
AND (
token = 'mezvZho5lDnrkcLGcWoqIRrLI0Tj88wjENAsUXB4keA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)