UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3npiiaL1H/CnENzauVqDga3/geeZrqeiT2W6HdzZGlk='
WHERE
key_id = 'c7a6ae6cf55ff2c7b478dd7f732c502ab982c51845c0c12756b2bab09da8584b'
AND (
token = '3npiiaL1H/CnENzauVqDga3/geeZrqeiT2W6HdzZGlk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)