UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xusgW5ZSvC7xg32dThva9IvfZZoIC5Br2lZOlOmdkuw='
WHERE
key_id = 'c0b29f2c55d67602785750d90774fd5a36c58de16d8958c528e035eb2bd3f52c'
AND (
token = 'xusgW5ZSvC7xg32dThva9IvfZZoIC5Br2lZOlOmdkuw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)