UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hDShXWLdzagupcWPlKXZZWzU2PlcSbEZsZCIvQ1Fnmg='
WHERE
key_id = '87b74c0fb1b7e1af810b3e4144135b43e4e88005eeb2afe27b2d589a57cd93cd'
AND (
token = 'hDShXWLdzagupcWPlKXZZWzU2PlcSbEZsZCIvQ1Fnmg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)