UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W6YxIIGu4kUfAN17o3q6KRd8G4eha75ZsqS2je4TKGc='
WHERE
key_id = '78875d93b3582aa6cfa54c841bf347ab450c62b6f290e95c8e761623394bbe9a'
AND (
token = 'W6YxIIGu4kUfAN17o3q6KRd8G4eha75ZsqS2je4TKGc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)