UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VjayH6nNay1Eq23ttZXs2RCk+20j02ebocMHXr2XtSo='
WHERE
key_id = '0e1e59ba2b5b58be2f1387aa38efcf2c539fa39ff4ae447d50911d7e47504a29'
AND (
token = 'VjayH6nNay1Eq23ttZXs2RCk+20j02ebocMHXr2XtSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)