UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HhQgWXKUyinM7pp4dURyGnPIecE8wKR3bO4/2JhbwNo='
WHERE
key_id = 'ec85b3aadc966caa72da37ec60d0559bda83642a4a8cd156402789fa220c359b'
AND (
token = 'HhQgWXKUyinM7pp4dURyGnPIecE8wKR3bO4/2JhbwNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)