UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XKsHev1Qn85CNjeRM+OuHK4Vgr5CoA4FE0d6wrXT8Ps='
WHERE
key_id = '42a2699e414fb78ebccdd441bb739c537b3fdd6574efa17a35aa633af0174247'
AND (
token = 'XKsHev1Qn85CNjeRM+OuHK4Vgr5CoA4FE0d6wrXT8Ps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)