UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DEXOcX/7ixL5aTzSZ42Khz4qd6EX3iV4/shV6HinB94='
WHERE
key_id = 'b4766f189dc1da60d24c32fe630d386d764dac643c02effae6adbbf7b9a629c1'
AND (
token = 'DEXOcX/7ixL5aTzSZ42Khz4qd6EX3iV4/shV6HinB94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)