UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p2mcYgc1bDKvTnWbx5mTnntE4u2koeqvyj8LTZfXQvw='
WHERE
key_id = '7d54c8475c92fd1192ab1532a08a8b9897a60250c9223e27170fb3f5dc097ad3'
AND (
token = 'p2mcYgc1bDKvTnWbx5mTnntE4u2koeqvyj8LTZfXQvw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)