UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lGxgjmz03JIOAOgqYHc7YtEPfN9nnVf6Mw6pYDjh87w='
WHERE
key_id = '5742a20de036f9184856ffea27baccef4f843c53349b91c4dc5964ea909ff4c7'
AND (
token = 'lGxgjmz03JIOAOgqYHc7YtEPfN9nnVf6Mw6pYDjh87w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)