UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nzwTl6SDHr47aqhpzTnmLucAK39d9jKmXKrrN4N3Neo='
WHERE
key_id = '9b7839bb6de64dccf4547138bce93a355faeaf27d1e27e255ded1ad41564b5c8'
AND (
token = 'nzwTl6SDHr47aqhpzTnmLucAK39d9jKmXKrrN4N3Neo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)