UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZdLRBcLumLEWQQMnWt1l/9Krqir30Jb+I0o9t9th5gM='
WHERE
key_id = 'bd2ac59ff21b54719896f776a70f2d07c2afacf6d19c84b6f42d1100401e017b'
AND (
token = 'ZdLRBcLumLEWQQMnWt1l/9Krqir30Jb+I0o9t9th5gM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)