UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DOzInh34EmkwSiFJapxSZOCYwE37MrmZ3zyk9O4X8iw='
WHERE
key_id = '55f99e7b2054e4368647150f42d797e99eec51c56a063dac67f7f20a0cc0de91'
AND (
token = 'DOzInh34EmkwSiFJapxSZOCYwE37MrmZ3zyk9O4X8iw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)