UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1FJ2p0HxSPv58rulo0jGMhhk9LZHkm3SFUOwX49m3Ds='
WHERE
key_id = 'f968510e2324be99725af51abdd3091b08ea971a73124e98c25adad3b308a5d1'
AND (
token = '1FJ2p0HxSPv58rulo0jGMhhk9LZHkm3SFUOwX49m3Ds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)