UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZNL0UHRbbnZ5cvkxbvT2Ig18/c9Wm42YHm0UKM20AWE='
WHERE
key_id = '101c435c7bc1a08bf1127b2be2862063f043e793d9f5f772d85a68be1d4874ab'
AND (
token = 'ZNL0UHRbbnZ5cvkxbvT2Ig18/c9Wm42YHm0UKM20AWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)