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