UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0nuKiYx2RoV8p491K0yLUe1gMg7mJoA4n4B55bWWfGU='
WHERE
key_id = '0c427ab4525e4e9d0622914fd00535dbb00d04bbb14cff942a8e2ebe823fa23f'
AND (
token = '0nuKiYx2RoV8p491K0yLUe1gMg7mJoA4n4B55bWWfGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)