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