UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qp8TPkARdAD3zGOK/PmGlDYFGXNTcIAmCzFOO67/98g='
WHERE
key_id = '24a639c2cb6ae97433c8f04f79cff619a9cfb6d17d3a27efbe6492cf1ed4139f'
AND (
token = 'Qp8TPkARdAD3zGOK/PmGlDYFGXNTcIAmCzFOO67/98g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)