UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aFPKCSAWjiYZ2DiaNUJcILgFwVy1KidRTbt86yiB6OI='
WHERE
key_id = '3d0889fe2f1482ed37fbb2a512e479475546ca77509248227c798dc449dac749'
AND (
token = 'aFPKCSAWjiYZ2DiaNUJcILgFwVy1KidRTbt86yiB6OI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)