UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E0xenc4vyKpTF7CMrZ08z8DGk9Iw7BHTwE1rt/+qeGE='
WHERE
key_id = 'b8e51e9f40cf468ba4303a504e7c4e1ed9e0032e5827c9ff761ba6aa71d3e817'
AND (
token = 'E0xenc4vyKpTF7CMrZ08z8DGk9Iw7BHTwE1rt/+qeGE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)