UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DROdPg7NjbTlxobH31jy/SCZlNu3+79aOU9BxCLBpFo='
WHERE
key_id = 'dce89ac9d6fa79ba7be450a6d0f64255ebebc221c4fcbced3e7c7c6372d09a31'
AND (
token = 'DROdPg7NjbTlxobH31jy/SCZlNu3+79aOU9BxCLBpFo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)