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