UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZsQgWAjO3D9Et72nAarTF1IBUuEjwEK56Z96qwoZ9Ec='
WHERE
key_id = '7cee40b4c1d5c68b2c05d2cb2abbd5ca970bfade34fb5a0cacc4c5bdfb7aa766'
AND (
token = 'ZsQgWAjO3D9Et72nAarTF1IBUuEjwEK56Z96qwoZ9Ec='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)