UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KZpci6N3kzeIqfFaKlOlELMGMO6Vq4MHhmdpSX6b2Mc='
WHERE
key_id = '9d7d361e30526d90c2c3c3084f715648b5e565f59d0193afab839564bfa72d63'
AND (
token = 'KZpci6N3kzeIqfFaKlOlELMGMO6Vq4MHhmdpSX6b2Mc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)