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