UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5dPInc+i4dOUgZ3CQgt+d0B975cAhQpu9v11kZZpPU0='
WHERE
key_id = 'e586bd2a2fbbbb99b81f25f5544cf519c121e7ed86c0b643b79f0120db30cf48'
AND (
token = '5dPInc+i4dOUgZ3CQgt+d0B975cAhQpu9v11kZZpPU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)