UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5W47FSa5Bhes4+aGDDEZZKZF6kmKD+2FMvSeqVd0dq0='
WHERE
key_id = 'e8a27116187cb3413d9634415fadc79d94112605b17e51d3c82362b39fa705b6'
AND (
token = '5W47FSa5Bhes4+aGDDEZZKZF6kmKD+2FMvSeqVd0dq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)