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