UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qml7iHpwOUxGr9BJ1eSj7vHbtpki5GY1xdePB8jmHjo='
WHERE
key_id = '3cb59f26d47b967dd881648540d35a4e94ac9fd50821667f6f78d1f73e5458ea'
AND (
token = 'qml7iHpwOUxGr9BJ1eSj7vHbtpki5GY1xdePB8jmHjo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)